USE [GOSALES_DW]
GO

/****** Object:  Table [dbo].[RETAILER_DIM]    Script Date: 10/18/2012 19:51:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RETAILER_DIM](
	[RETAILER_CODE] [int] NOT NULL,
	[COMPANY_NAME] [nvarchar](50) NOT NULL,
	[RETAILER_SITE_CODE] [int] NOT NULL,
	[RTL_ADDRESS1] [nvarchar](50) NOT NULL,
	[RTL_ADDRESS2] [nvarchar](50) NULL,
	[RTL_CITY] [nvarchar](40) NOT NULL,
	[RTL_PROV_STATE] [nvarchar](50) NULL,
	[COUNTRY_CODE] [int] NOT NULL,
	[COUNTRY] [nvarchar](40) NULL
) ON [PRIMARY]

GO


